Minimum (fld), Minimum (fld, condFld), Minimum (fld, condFld, cond), Minimum (x)

Basic and Crystal syntax.

Arguments
Returns

Fractional Number

Action

Enables you to find the minimum value that appears in a set of values. For example:

Examples

The following examples are applicable to both Basic and Crystal syntax:

Minimum({file.QTY})

Returns the lowest value in the QTY field.

Minimum({orders.AMOUNT}, {orders.CUSTOMER ID})

Identifies the smallest order in each group of orders in the Amount field (the smallest order for each month). The orders are separated into groups whenever the value in the Customer ID field changes.

Minimum({orders.AMOUNT}, {orders.ORDER DATE}, "monthly")

Identifies the smallest order in each group of orders in the Amount field (the smallest order for each month). The orders are separated into groups whenever the value in the Date field changes to a new month.

The following example is applicable to Crystal syntax:

Minimum also allows you to set a ceiling on a calculation. For example: Minimum([{file.COMMISSION}, 2500]) returns the commission accrued up to a cap or ceiling of 2500. Once accrued commission passes the $2500 mark, this expression returns 2500. Thus:

Minimum([{file.COMMISSION}, 2500])

Returns 1575 where commission = 1575.

Note:    Using this function in a formula forces the formula to be evaluated at print time.

For more information on evaluation time considerations, see Evaluation Time functions.



Seagate Software IMG Holdings, Inc.
http://www.seagatesoftware.com
Support services:
http://support.seagatesoftware.com